1 <?php
2 error_reporting(0);//turning off error reporting
3 include("connect.php");
4 $sql="SELECT studentid FROM students where studentid LIKE '%CCA%'";
5 $records=mysqli_query($db,$sql);
6
7
8 ?>
9 <?php
10 SESSION_START();
11 ?>
12
13 <!DOCTYPE html>
14 <html>
15
16 <head>
17 <meta charset="utf-8">
18 <meta name="viewport" content="width=device-width, initial-scale=1.0">
19 <title>school management system</title>
20 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
21 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
22 <link href="assets/css/loader.css" rel="stylesheet" />
23 <script src="assets/js/canvasjs.min.js"></script>
24 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
25 <script src="assets/js/jquery-3.2.1.js"></script>
26 <!--codes to run the script for constituencies and counties-->
27 <script type='text/javascript'>
28 function OnSelectionChange(county_id) {
29 var selectedOption = county_id.options[county_id.selectedIndex];
30 document.getElementById('selectedcounty').value = selectedOption.value;
31
32 }
33 </script>
34
35
36
37
38 <!--codes to run the script for constituencies and counties-->
39 <style type="text/css">
40 h4{
41 color:red;
42 }
43 </style>
44 <!--styling up the heading of form-->
45
46 </head>
47
48 <body >
49 <!--end of heading section-->
50 <ul class="nav navbar-right top-nav">
51 <div class="dropdown">
52 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
53 <?php
54 //Check to see if the user is logged in.if not redirect user to the loging page.
55
56 if(isset($_SESSION['fname']))
57 {
58 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
59 }else{
60 echo "<script type='text/javascript'>
61 alert( 'You must Log in to use the system');
62 </script>";
63 echo "<script>
64 window.location = 'index.php'
65 </script>";
66 }
67 ?>
68 <span class="caret"></span></button>
69 <ul class="dropdown-menu">
70 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
71 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
72 <li class="divider"></li>
73 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
74 </ul>
75 </div>
76 </ul>
77 <!--************************************************-->
78 <div style="
79 font-family:Nyala, Arial;
80 text-align: left;
81 background-color: #526F35;
82 padding: 20px;
83 color:white;
84 width: 100%;
85 height: 150px;">
86 <!--This codes to load the image loader-->
87 <div id="loading">
88 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
89 </div>
90 <!--this is the heading section-->
91 <h2>
92 <?php
93 $sql="SELECT * FROM companyinfo";
94 $result=mysqli_query($db,$sql) or die("error getting data");
95 $num_rows=mysqli_num_rows($result);
96 while($row=mysqli_fetch_array($result))
97 {
98 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
99 $cname = $row['cname'];
100 $cemail = $row['cemail'];
101 $ccontact = $row['ccontact'];
102 $clocation = $row['clocation'];
103 }?>
104 <?php
105 echo $cname;
106 ?>
107
108 <div style="float:right; font-size:20px;text-align:right;">
109
110 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
111 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
112 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
113
114 </div>
115 </h2>
116 </div>
117 <!--end of heading section-->
118 <div>
119 <ul class="nav nav-tabs">
120 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
121 <li class="active"><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
122 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
123 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
124 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
125 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
126 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
127 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
128 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
129 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
130
131 </ul>
132 <div class="tab-content">
133 <div class="tab-pane active" role="tabpanel" id="tab-1">
134
135 <p>
136 <div class="table-responsive" >
137 <!--**************************************************************************************************************************-->
138 <div class="container" style="width:100%">
139
140 <ul class="nav nav-tabs">
141 <li class="active"><a href="students.php">New Student <img src="assets/img/new.png"> </a></li>
142 <li><a href="viewstudentrecord.php">View List<img src="assets/img/view2.png"></a></li>
143 <li><a href="viewstudentsedit1.php">Edit Student<img src="assets/img/view2.png"></a></li>
144 <li><a href="csvstudents.php">Import/Export Data <img src="assets/img/import.png"></a></li>
145 <li><a href="reports_students.php">Reports </a></li>
146 </ul>
147 <br>
148
149 </div>
150 <!--**************ths is the success msg on saving the cord-->
151
152 <!--*************************************************************************************************************************-->
153 <div class="container-fluid">
154 <div class="row">
155 <div class="col-lg-6 col-lg-offset-3">
156 <div class="panel panel-primary">
157 <div class="panel-heading">Add new student</div>
158
159 <!-- /.panel-heading -->
160 <div class="panel-body">
161 <div class="table">
162
163 <form action="students.php" method="POST" enctype="multipart/form-data">
164 <label>Admission number</label>
165 <input type="text" name="admission_number" placeholder="Admission number" id="ssname" class="form-control">
166 <div style="float:left; position:relative">
167 <h4>Personal Details</h4>
168
169 <label>Sir name</label>
170 <input type="text" name="sirname" placeholder="e.g Kimani" id="ssname" class="form-control">
171
172 <label>Firstname</label>
173 <input type="text" name="firstname" placeholder="e.g Jane" id="sfname" class="form-control" >
174
175 <label>Last Name</label>
176 <input type="text" name="lastname" placeholder="e.g Wangechi" id="slname" class="form-control">
177
178 <label>ID/Passport NO.</label>
179 <input type="text" name="idno" class="form-control" placeholder="optional">
180 <label>DOB</label>
181 <input type="date" name="dateofbirth" required class="form-control" max="2010-12-31">
182 <label>Gender</label>
183 <select name="gender" id="gender" class="form-control">
184 <?php
185 $sql3="SELECT gendername FROM genderset";
186 $records3=mysqli_query($db,$sql3);
187
188 while($users3=mysqli_fetch_array($records3))
189 {
190 echo "<option>".$users3['gendername']."</option>";
191 }
192 ?></select>
193
194 <!-- <label>Country</label>
195 <input type="text" name="country_id" placeholder="kenya" value="Kenya" class="form-control" />
196
197 <label>County</label>
198 <select name="county_id" id="county_id" onchange="OnSelectionChange(this)" class="form-control">
199 <?php
200 $sql4="SELECT countyname FROM counties";
201 $records4=mysqli_query($db,$sql4);
202 while($users4=mysqli_fetch_array($records4))
203 {
204 echo "<option>".$users4['countyname']."</option>";
205 $countyname=$users4['countyname'];
206 }
207
208 ?></select>
209
210 <label> Constituency</label>
211 <select name="constituency_id" id="constituency_id" onchange="onclick(this)" class="form-control">
212 <?php
213
214 $sql1="SELECT constituencyname FROM constituency";
215 $records1=mysqli_query($db,$sql1);
216 while($row=mysqli_fetch_array($records1))
217 {
218 echo "<option>".$row['constituencyname']."</option>";
219 }
220 ?></select>
221 </div> -->
222 <!--section two-->
223 <div style="float:right; position:relative">
224 <h4>Contact Details</h4>
225
226 <label> Mobile</label>
227 <input type="number" name="mobile" class="form-control">
228 <label> Email</label>
229 <input type="email" name="email" class="form-control" placeholder="xyz@gmail.com">
230
231 <label> Address</label>
232 <input type="text" name="address" class="form-control" >
233
234 <label> Zip Code</label>
235 <input type="text" name="zipcode" class="form-control">
236
237 <label> Date of Admission</label>
238 <input type="date" name="reg_date" required class="form-control" value="<?php echo date('Y-m-d'); ?>" >
239
240 <label>Class. </label>
241 <select name="course_id" required class="form-control">
242 <?php
243 $sql2="SELECT * FROM course ";
244 $records2=mysqli_query($db,$sql2);
245 $out=mysqli_num_rows($records2);
246 //check wheather or not classes are entered
247 if ($out=0)
248 {
249 $out="It seems there are classes added yet[<a href='course.php'>Add Class</a>] ";
250 }
251 else{
252 $out=mysqli_num_rows($records2). " Classes found [<a href='course.php'>Add Class</a>] ";
253 }
254 //end of check process. the output is stored in variable $out
255 while($users2=mysqli_fetch_array($records2))
256 {
257 echo "<option>".$users2['coursename']."</option>";
258 }
259
260 ?></select>
261 <?php echo '<font color="red"><i>'.$out. '</i></font>'?><br>
262
263 <!-- <label>Status</label>
264 <select name="border" required class="form-control">
265 <?php
266 $sql3="SELECT stutus_name FROM border";
267 $records3=mysqli_query($db,$sql3);
268
269 while($users3=mysqli_fetch_array($records3))
270 {
271 echo "<option>".$users3['stutus_name']."</option>";
272 }
273 ?></select>
274 NB:Additional charges to all borders
275 </div> -->
276 <!--this is section three-->
277 <div style="float:left; position:relative; clear:both;">
278
279 <h4>Guardian/Parent and other Details for student</h4>
280
281 <label> Sir name</label>
282 <input type="text" name="psirname" id="sn" class="form-control">
283
284 <label>Firstname Name</label>
285 <input type="text" name="pfirstname" id="fn" class="form-control">
286
287 <label>Last Name</label>
288 <input type="text" name="plastname" class="form-control">
289
290 <label>Mobile</label>
291 <input type="number" name="pmobile" class="form-control">
292
293 <label>Emergency Contact</label>
294 <input type="number" name="emergency_contact" class="form-control">
295
296 <label>Relationship </label>
297 <input type="text" name="prelationship" placeholder="Father" class="form-control"><br>
298
299
300 <input type="submit" name="register" value="Save Record" class="btn btn-success"><br><br>
301 </div>
302 </form></div>
303 </div>
304 </div>
305 </div>
306 </div>
307 </div>
308
309 <!--*************************************PHP CODES TO SAVE THE DATA************************************************-->
310 <?php
311 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
312 if (isset($_POST['register'])){
313
314 $xx=$_POST['county_id'];
315 $sql="SELECT * FROM counties WHERE countyname='$xx'";
316 $user_query=mysqli_query($db,$sql) or die("error getting data");
317 while($row = mysqli_fetch_array($user_query)){
318 $county_id = $row['county_id'];}
319
320 $xx=$_POST['constituency_id'];
321 $sql="SELECT * FROM constituency WHERE constituencyname='$xx'";
322 $user_query=mysqli_query($db,$sql) or die("error getting data");
323 while($row = mysqli_fetch_array($user_query)){
324 $constituency_id= $row['constituency_id'];}
325
326 $xx=$_POST['course_id'];
327 $sql="SELECT * FROM course WHERE coursename='$xx'";
328 $user_query=mysqli_query($db,$sql) or die("error getting data");
329 while($row = mysqli_fetch_array($user_query)){
330 $course_id = $row['course_id'];
331 $feepayable = $row['feepayable'];}
332
333 $xx=$_POST['border'];
334 $sql="SELECT * FROM border WHERE stutus_name='$xx'";
335 $user_query=mysqli_query($db,$sql) or die("error getting data");
336 while($row = mysqli_fetch_array($user_query)){
337 $amount = $row['amount'];
338 $stutus_name = $row['stutus_name'];}
339
340 $xx=$_POST['country_id'];
341 $sql="SELECT * FROM countries WHERE countryname='$xx'";
342 $user_query=mysqli_query($db,$sql) or die("error getting data");
343 while($row = mysqli_fetch_array($user_query)){
344 $country_id = $row['country_id'];}
345
346 $finalfee=$amount +$feepayable;
347
348
349 $admission_number=strtoupper(addslashes($_POST['admission_number']));
350 $reg_date=strtoupper(addslashes($_POST['reg_date']));
351 $sirname=strtoupper(addslashes($_POST['sirname']));
352 $firstname=strtoupper(addslashes($_POST['firstname']));
353 $lastname=strtoupper(addslashes($_POST['lastname']));
354 $idno=strtoupper(addslashes($_POST['idno']));
355 $dateofbirth=strtoupper(addslashes($_POST['dateofbirth']));
356 $gender=strtoupper(addslashes($_POST['gender']));
357 $mobile=strtoupper(addslashes($_POST['mobile']));
358 $emergency_contact=strtoupper(addslashes($_POST['emergency_contact']));
359 $email=strtoupper(addslashes($_POST['email']));
360 $address=strtoupper(addslashes($_POST['address']));
361 $zipcode=strtoupper(addslashes($_POST['zipcode']));
362 $border=addslashes($_POST['border']);
363 $monthh = strtotime('date()');
364 $mon = date('Y-m-d',$monthh);
365
366 //<!--**************************************************************>
367 $admission_number=strtoupper(addslashes($_POST['admission_number']));
368 $psirname=strtoupper(addslashes($_POST['psirname']));
369 $pfirstname=strtoupper(addslashes($_POST['pfirstname']));
370 $plastname=strtoupper(addslashes($_POST['plastname']));
371 $pmobile=strtoupper(addslashes($_POST['pmobile']));
372 $prelationship=strtoupper(addslashes($_POST['prelationship']));
373
374 mysqli_query($conn,"INSERT INTO studentstable(admission_number, sirname, firstname, lastname, idno, dateofbirth, gender, country_id, county_id, constituency_id, mobile, email, address, zipcode, course_id, border,reg_date, feepayable, emergency_contact)
375 VALUES ('$admission_number','$sirname','$firstname','$lastname','$idno','$dateofbirth','$gender','$country_id','$county_id','$constituency_id','$mobile','$email','$address','$zipcode','$course_id','$border','$reg_date','$finalfee','$emergency_contact')") or die(mysqli_error());
376 mysqli_query($conn,"INSERT INTO parents(admission_number, psirname, pfirstname, plastname, pmobile, prelationship)
377 VALUES('$admission_number','$psirname','$pfirstname','$plastname','$pmobile','$prelationship')") or die(mysqli_error());
378
379 ?>
380 <?php
381 $query="SELECT * FROM studentstable";
382 $records2=mysqli_query($db,$query);
383 while($rec=mysqli_fetch_array($records2))
384 {
385 $id = $rec['admission_number'];
386 }?>
387
388 <script>
389
390 alert('Succsessfully Save. Proceed to fee payment');
391 window.location = "fee.php?id=<?php echo $id;?>";
392 </script>
393 <?php
394 //<!--*******************************try add parent's details******************************************************-->
395
396 }?>
397 <!--**********************************************************************************************************************-->
398
399
400 </div>
401 </p>
402
403
404 </div>
405
406 </div>
407 </div>
408
409 <div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
410 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
411 </div>
412 <script src="assets/js/jquery.min.js"></script>
413 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
414 <script src="assets/js/affix.js"></script>
415 <script src="assets/js/alert.js"></script>
416 <script src="assets/js/alert1.js"></script>
417 <script src="assets/js/bootstrap.js"></script>
418 <script src="assets/js/bootstrap.min.js"></script>
419 <script src="assets/js/bootstrap-datepicker.js"></script>
420 <script src="assets/js/bootstrap-wysihtml5.js"></script>
421 <script src="assets/js/button.js"></script>
422 <script src="assets/js/carousel.js"></script>
423 <script src="assets/js/chosen.jquery.min.js"></script>
424 <script src="assets/js/ckeditor.js"></script>
425 <script src="assets/js/collapse.js"></script>
426 <script src="assets/js/color.js"></script>
427 <script src="assets/js/dropdown.js"></script>
428 <script src="assets/js/DT_bootstrap.js"></script>
429 <script src="assets/js/dynamic.js"></script>
430 <script src="assets/js/ie-emulation-modes-warning.js"></script>
431 <script src="assets/js/jquery.dataTables.js"></script>
432 <script src="assets/js/jquery.dataTables.min.js"></script>
433 <script src="assets/js/jquery.dialog.js"></script>
434 <script src="assets/js/jquery.hoverdir.js"></script>
435 <script src="assets/js/jquery.jgrowl.js"></script>
436 <script src="assets/js/jquery.knob.js"></script>
437 <script src="assets/js/jquery.uniform.min.js"></script>
438 <script src="assets/js/jquery-1.8.3.min.js"></script>
439 <script src="assets/js/jquery-1.9.1.js"></script>
440 <script src="assets/js/jquery-1.9.1.min.js"></script>
441 <script src="assets/js/jquery-1.10.2.js"></script>
442 <script src="assets/js/jquery-1.11.0.js"></script>
443 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
444 <script src="assets/js/jquery-ui-1.10.3.js"></script>
445 <script src="assets/js/modal.js"></script>
446 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
447 <script src="assets/js/myjquery.js"></script>
448 <script src="assets/js/myjquery1.js"></script>
449 <script src="assets/js/npm.js"></script>
450 <script src="assets/js/popover.js"></script>
451 <script src="assets/js/profile.js"></script>
452 <script src="assets/js/raphael-min.js"></script>
453 <script src="assets/js/sb-admin-2.js"></script>
454 <script src="assets/js/scripts.js"></script>
455 <script src="assets/js/scrollspy.js"></script>
456 <script src="assets/js/tab.js"></script>
457 <script src="assets/js/tooltip.js"></script>
458 <script src="assets/js/transition.js"></script>
459 <script src="assets/js/wysihtml5-0.3.0.js"></script>
460 <!--when everything is fine the loades stops loadeing-->
461 <script language="javascript" type="text/javascript">
462 $(window).load(function()
463 {
464 $('#loading').hide();
465 });
466 </script>
467
468 </body>
469
470 </html>